Evaluate Rows Number In a Table (Wait for SQL)
Description
Wait for SQL is a Process Entry in the Utilities plugin for Process Studio Processes. The Wait for SQL process entry scans a database and checks if the specified database table meets user - defined conditions
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Process Entry name | Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name. |
| 2 | Connection | Identifies the database connection to use |
| 3 | Target schema | Name of the table schema to evaluate |
| 4 | Target table name | Name of the table to evaluate |
| 5 | Success when rows count | Defines the evaluation method used to compare the number of rows with the given value |
| 6 | Value | Defines the value used for the evaluation |
| 7 | Maximum timeout | After this timeout period, the process entry continues with a fail, by default, or success, if the Success on timeout option is checked |
| 8 | Check cycle time | Sets the amount time between evaluations |
| 9 | Success on timeout | Defines process entry success behavior when timeout is reached---when checked, reaching the maximum timeout limit causes the process entry to succeed. When left unchecked, reaching the maximum timeout limit causes the process entry to fail. |
| 10 | Custom SQL | Enables the use of custom SQL queries |
| 11 | Use variable substitution | Replaces environment variables in the SQL script with their actual value |
| 12 | Clear list of result rows before execution | Clears the list of result rows before running this process entry |
| 13 | Add rows to result | Includes returned rows to the result set |